Setting General Connection Properties

This section describes how to use a Google Cloud BigQuery database as a data warehouse in a Qlik Compose project.

To define Google Cloud BigQuery as a data warehouse:

1. Open your project and click Manage in the bottom left of the Databases panel.

   The Manage Databases window opens.

2. Click the New toolbar button or click the Add new database link in the middle of the window.

   The New Data Warehouse dialog box opens.

3. From the Type drop-down list, select the desired data warehouse.

4. Enter the information as described in the table below.

   • Connection input mode: Select Standard or Advanced.

     If you selected Standard:

     • Paste the contents of the JSON file (including curly brackets) that was downloaded when you created your BigQuery service account key, into the Service account key field.

     If you selected Advanced, specify the following:

     • ODBC Connection String: Enter a string of parameters required to connect to BigQuery via the Simba ODBC Driver.
     • JDBC Connection String: Enter a string of parameters required to connect to BigQuery via the Simba JDBC Driver.
     Warning noteCompose will concatenate the dataset name to the ODBC/JDBC connection string.
   • Region: Where to upload the dataset created by Compose.
   • Data Warehouse dataset: Specify the dataset in which to create the data warehouse tables.
   • Data mart dataset: Specify the dataset in which to create the data mart.
5. Click Test Connection to verify that Compose is able to establish a connection with the specified data warehouse.

6. Click OK to save your settings.

   The database is added to the list on the left side of the Manage Databases window.